Intelligent Multidimensional Database Interface

Zagazig, Egypt ABSTRACT In the present computing world, most new-generation database applications need for intelligent interface to enhance efficient interactions between database and the users. Database query language SQL could be difficult to the non-expert users and learning these formal queries takes a lot of time. In this paper, we discussed mapping of natural language queries to SQL rather than building normal query and a user simply poses the question in everyday verbiage language. Furthermore, we introduce a dynamic approach to determine the tables and attributes involved in the query by using database metadata schema. Our approach will minimize the time that used to build the queries thus minimizing the code size and effort for building query. We also propose a dynamic component that helps in building any NLIDB this component is linked to all the NLIDB system's components and helps to build the dictionaries and database schema graph. KEYWORD Intelligent Multidimensional Database Interface (IMDI), Natural Language Interface to Databases (NLIDB), Database Management System (DBMS), Structured Query Language (SQL).